SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984506 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984506 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473336,265213,1044346,123831,307374,878731,388749,358713,975279,396843,976243,434957,348079,303233,13865,747784,1041638,769055,222572,401800,387041,848096,338088,834678,19688,406107,1018019,857501,622259,908143,77796,669786,115798,13349,260771,263967,1015908,798930,35131,81693,784754,161850,129528,269823,387934,648974,737180,497877,260359,640463,70145,102182,350019,196188,602871,61237,667010,960475,326671,244564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]