SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34102 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34102 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821590,648344,502593,692623,609630,490173,439631,661120,816484,844583,379436,782158,337565,644231,165761,250901,973526,275441,1035255,641098,284414,451476,973364,535393,974654,850724,1005818,522425,423777,312893,704503,725194,695640,1534,324889,589512,873048,256264,130442,270905,850583,385231,817804,220384,853722,446893,761553,1011492,302118,876424,545768,543054,818864,944893,613195,178407,570357,183584,309528,823973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]