SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111490 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111490 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515552,756855,536023,641562,366391,123748,792010,438561,512067,345102,828098,530962,46376,374489,981240,709058,535554,400903,197491,40827,52974,952464,717826,883377,863030,1034070,674254,666867,921145,680464,762044,599518,121442,1022660,515928,681853,637854,282596,618699,66253,957347,889673,1005900,207503,760844,87309,530506,1028433,757577,576893,92245,824832,898148,240142,637082,589123,722496,602617,688057,619083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]