SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101207 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101207 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863895,864821,105727,957080,653357,678694,622342,664521,959084,561314,131258,839980,444641,651217,555838,653483,968765,95542,23180,209945,10490,534226,222224,851449,140071,29361,824778,335181,739951,275379,603997,304127,378318,937107,351805,111928,979179,257842,763805,1048391,784841,899191,504935,938762,257900,99873,733115,328544,915985,533881,423176,490624,289468,98272,334921,18133,320407,512398,484380,990607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001199s ]