SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581213 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581213 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203604,403609,707883,649382,887493,918315,508180,532734,198352,903707,699299,104361,172131,568691,443879,121648,961770,342226,458958,1006321,556734,856712,979902,2730,136574,880932,821413,407695,314680,829262,700035,707599,708706,374390,614175,78867,824090,975677,18451,342491,518947,615415,173865,921089,243920,948099,631008,402200,392515,1013869,251517,243690,51477,186280,448182,186685,688159,675576,129827,637415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]