SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284788 LIMIT 1 [ RunTime:0.000822s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284788 [ RunTime:0.002697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544517,1021413,773903,531440,804228,557880,172736,665763,358527,99745,836578,561883,36483,997782,11471,100639,175483,961635,77517,244216,584518,239988,178908,94946,101782,1002239,381743,66371,568521,929174,991529,255649,249848,316013,1010937,595934,243998,623211,715487,367749,372359,766465,197369,145006,458054,787913,847781,289727,899709,77285,707169,940821,35906,1039643,108603,854566,223463,831414,233025,494777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]