SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039415 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039415 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543073,857436,637406,672254,457048,878281,299718,173945,644033,749220,65459,775769,825764,930873,845443,733938,543624,1028765,965825,323699,90220,152008,207335,931566,93403,944351,552442,777462,140478,322860,719808,30114,986995,296454,260354,102305,875892,85403,693549,347705,516760,543376,527641,773810,298415,136355,346227,725943,959875,48774,880150,147163,404939,1021764,220421,714525,406495,674023,764367,126394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]