SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007246 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007246 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016614,966389,795539,482778,460970,216438,787498,528513,155592,55123,136678,560705,840374,742707,978794,564162,721085,429807,748139,208334,874760,452774,967021,802727,197602,447686,392974,912255,340045,814712,685264,966934,88617,490056,490208,786260,926693,987250,848886,238489,86174,636489,1043280,912370,858876,988389,967415,680921,581148,257923,1000677,397342,861821,973695,21715,919076,772480,747606,1002874,88193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]