SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285043 LIMIT 1 [ RunTime:0.000964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285043 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244503,563388,378106,7138,601506,457306,336260,195735,651091,678232,74955,645911,230481,394567,28941,248857,93405,564060,439937,978509,98475,59138,329501,393900,40845,583281,944326,62655,79339,241736,637100,354645,919585,205594,567089,515943,150114,864736,640949,70621,969823,226780,465970,243678,295084,743226,680300,168903,589374,85469,551615,421210,860991,145425,14570,509416,346673,163598,423374,32205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]