SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015920 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015920 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638294,532556,965505,648981,681715,668404,235886,868273,990337,622875,78146,1021825,312966,882558,980699,442353,681660,415072,217552,629902,656453,701516,704251,1037219,520141,431693,470604,271093,150499,1006239,138220,454814,9178,943872,859687,989150,988154,65950,111433,462779,202093,1036406,161963,521001,731063,319289,763566,52364,1029777,207422,834373,975333,711562,610958,438496,27969,960416,237239,617213,532148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]