SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028368 LIMIT 1 [ RunTime:0.000961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028368 [ RunTime:0.004040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005768,530645,167303,811737,554483,912676,531385,289672,182865,847220,636807,353673,295685,898277,363083,302276,303025,341393,1010434,617809,740054,883739,429998,671001,497816,241335,863130,1000548,4244,29063,575550,976956,586399,450796,210058,996500,502869,194184,9355,671951,3176,832664,329843,153134,770684,147635,892906,748664,195882,364202,457489,686585,539143,881338,888244,995554,96306,118600,954510,891996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001914s ]