SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531460 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531460 [ RunTime:0.002051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906308,921162,1025459,476842,1024792,564809,660914,700367,617990,928151,474089,681448,514520,181386,846363,795452,649196,761953,869659,145320,760860,1013618,49588,398309,305008,334233,120562,335362,623406,848571,385417,593363,119032,521962,78043,663591,798107,255150,541050,560555,910212,4439,516024,483798,844716,719237,904989,314347,565755,200868,914036,74331,228602,361757,591634,140303,179710,396372,262533,903603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]