SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318945 LIMIT 1 [ RunTime:0.001664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318945 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949842,309823,1033530,239805,637796,304781,687072,842976,456348,90414,313048,838217,725882,961354,588019,713832,630135,1007750,796314,1046683,725385,206762,793448,297688,844036,404971,589745,426007,757624,20080,186550,530525,851413,919201,562860,325082,139739,285633,1028743,919867,425032,561821,424182,425839,1027825,558554,928718,702146,215193,1025255,71487,410540,957467,502282,890205,951528,918632,437222,500921,302395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000915s ]