SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508147 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508147 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008684,95083,246247,199057,427428,647468,132708,891008,1008604,39976,120021,582277,682815,189440,163457,265493,845160,665235,77788,112206,240164,139471,19991,514675,127938,443137,188145,709420,672160,515699,111658,881558,699666,412650,478099,827856,106648,169990,297034,754227,491700,110324,901618,120729,310661,107482,439829,383026,8254,648635,852844,771240,586814,475407,293530,939393,147144,63350,499159,946384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]