SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017130 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017130 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535133,1027007,209809,779961,1029024,840082,276247,570104,886124,738962,176780,645904,751498,166464,727682,787184,287665,777366,1002344,986823,170381,820915,555076,372867,548935,441530,287926,284605,25624,1035778,638700,497204,119285,374119,400731,846159,544675,648294,74039,564875,302359,1023386,940783,749061,866590,168795,740743,47569,773834,556968,238452,25305,689332,262798,591583,461079,293857,852630,245887,47538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004064s ]