SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804342 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804342 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447071,952949,872946,677063,859253,185927,341950,743765,204133,679491,772091,101302,71758,492462,661964,1045014,1022363,670530,341961,409678,459061,265718,185959,14335,430842,141545,964513,326291,571217,177859,301834,564502,131273,545452,648155,5599,662717,1019572,948860,992831,887340,579386,957148,816308,346259,660723,514569,861742,985603,263690,45995,603243,676895,461294,527732,806841,283875,1036228,336224,675731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]