SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459913 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459913 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184327,20173,31896,229063,704406,797690,154428,28055,143763,315633,931593,726948,438591,786830,65926,336520,997063,862139,363141,198778,271528,249641,765246,770536,374467,971817,630713,930250,386206,246251,396871,101126,927899,285290,572235,137082,546432,782612,495096,734551,661886,102857,823626,129326,390039,13345,510426,710824,606584,601066,435209,272834,638942,351678,413342,655725,487820,325373,294805,116032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]