SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364201 LIMIT 1 [ RunTime:0.002596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364201 [ RunTime:0.006997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15616,124718,805274,517569,1016995,672395,108446,602841,474363,628735,784305,221573,6522,117693,623041,187299,236243,95428,479183,717653,641437,509279,279631,571692,54973,927068,478373,967173,858681,757565,719039,336205,790742,499550,55117,983601,677765,353113,629391,873550,278670,15040,31929,315381,909924,242941,825972,644448,764136,607332,799411,735987,569403,1037934,425861,104105,140642,96398,32196,328027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003124s ]