SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5610 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5610 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576592,1013134,684939,992600,73418,390495,842363,563739,628402,508756,118678,646606,192094,848885,250364,981998,264867,236529,1036474,813591,25991,160385,185174,152361,390265,96228,585186,296912,367299,236550,434212,217072,678368,256611,329535,700736,408976,700248,420177,775231,430562,584935,875942,216905,924622,876754,27410,937835,855917,436225,542893,920480,159271,619399,77932,845314,724042,23485,1011775,321441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001381s ]