SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112630 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112630 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580509,398508,125539,535244,557236,901146,935008,792932,692890,843519,352875,134190,916306,441691,933478,1013863,545266,964505,789051,522685,837664,961220,141708,300938,212410,370428,222013,758808,178184,349684,1023511,11298,25400,439949,260032,1025799,173426,841220,430942,976541,237793,229981,979631,604924,34854,105919,707963,270145,257780,389218,95853,271024,650961,751660,442957,193651,766459,621581,32297,772474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]