SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009099 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009099 [ RunTime:0.009427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598618,100037,356712,565517,955437,869036,819447,801583,1010671,12744,886280,260180,506067,1030512,627111,508214,542705,444934,742371,337788,351551,597587,578393,541849,1006728,823272,300574,189901,561278,558556,865097,887712,389295,354830,135541,68535,407544,168246,818668,930739,972766,132813,16090,309692,571049,1007416,359566,18175,467415,240427,561717,965705,412662,320795,216410,198200,664110,79444,205104,102427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001960s ]