SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537457 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537457 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411351,772618,494982,893414,873686,479169,623168,595677,987983,490746,367681,13329,780757,579448,241477,135814,755637,298198,371310,102402,310722,225405,208022,600225,425768,64784,374998,642110,337356,702464,64964,55547,705121,226934,207739,537103,383908,910605,1040929,748329,868440,71529,1011571,341374,730514,944873,472462,316506,1015185,325747,464233,878320,929731,230340,178726,835166,694369,461798,599455,1013387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]