SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381022 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381022 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274729,120913,64360,461399,61902,594095,551965,994427,673087,677001,250225,589688,853431,484965,580875,900806,121630,400464,253556,1047726,139989,745788,935865,868895,951477,848442,647799,357103,756855,870873,522450,1006360,540103,853335,16105,312056,610645,45502,92442,229497,704093,1003460,93752,329301,873962,679382,900954,455182,105762,609525,746789,37888,14138,886486,1039748,648151,466864,126218,131701,51649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]