SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107704 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107704 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19348,315709,715725,897496,762310,276981,193648,509928,893803,647795,400961,408092,90190,499309,619095,21091,767471,863309,795760,302434,146153,433705,595886,72263,236572,738970,723163,666442,133830,449534,59323,903051,558325,35253,310420,65138,181706,999008,285521,448428,928083,979575,455018,157096,604043,441063,660118,25231,74234,34315,617914,314800,67067,388907,556485,600469,600641,140369,300954,398150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]