SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040157 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040157 [ RunTime:0.002399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458051,852218,256666,728918,692890,413935,883031,534256,41841,1029061,489476,752303,675176,190674,341763,274926,540337,891053,374309,642291,292152,791976,266955,785475,255810,1020290,82309,899159,1047383,207414,339074,967830,505568,734917,301218,67046,728107,214024,193663,854188,74543,119216,849825,267704,9401,273296,338054,773163,440937,280179,510519,101976,18375,899844,216486,470862,531424,390286,33580,719385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]