SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414915 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414915 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723803,662560,946110,994888,504434,536255,847399,378819,878833,174972,814356,57656,109851,888528,295926,514806,784621,126627,123986,110876,1045261,667839,60221,564,272101,228561,263101,698789,91825,816562,658077,29187,770837,430998,1037606,264144,608730,556843,566604,231682,932970,833900,37437,289544,390133,120023,983745,697206,899857,875485,586223,837521,361159,981480,8640,543881,202182,370528,533482,671875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]