SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555080 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555080 [ RunTime:0.006323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618116,1000378,202093,33598,94150,225497,472352,906083,415168,68275,918809,1009945,608149,212431,680518,482139,330388,366382,98420,94492,150223,82406,85537,1021686,426647,668680,363222,626855,863473,136134,769592,431777,242074,371428,319693,229888,158138,447300,203236,30162,625806,787846,728488,192474,75401,628891,700584,517718,599034,385235,734290,437224,168556,1001298,925596,1045635,791189,883937,3054,475808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]