SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103416 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103416 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358662,939794,897633,46298,158448,321057,772329,160071,554549,640661,904546,529343,372409,812076,467184,272457,667980,155972,657891,400770,229907,547082,618639,885212,200262,465264,493755,1041030,675324,556506,56617,321151,465652,152738,194171,901613,83749,919226,587569,484611,893834,293791,203909,554718,626805,612167,1011342,839491,959279,223769,647747,345727,700908,572254,933230,685168,868826,227196,702860,300474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002049s ]