SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393406 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393406 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52541,245317,384145,361586,231538,1029819,201667,569275,542917,1047877,523858,504777,199202,122337,949419,936178,696358,476358,37729,1020849,269489,426391,651904,719632,618829,146015,512889,647206,486226,749975,685400,890408,97704,9558,455589,981310,366156,356526,591018,12174,730390,398180,866023,710205,990935,884168,243461,842169,994993,683332,330270,374989,907037,987384,1031630,991592,913230,54320,103897,714104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]