SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033543 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033543 [ RunTime:0.003250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292532,182209,429954,371472,1012628,611168,264006,750675,761290,914537,540302,445581,692843,930373,788102,585136,860155,1048014,76558,459996,984280,939441,300191,38618,210553,633293,378915,981576,828179,296483,996859,593949,272640,203809,597847,840431,313552,349406,931279,643939,1020442,828699,456317,604151,741619,891979,943306,338228,43742,289422,887544,974394,823296,781211,600528,107357,792509,248443,639580,888665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]