SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412243 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412243 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324324,171488,958502,990181,313187,696287,1031779,525490,658008,18433,8170,718412,11919,266441,329298,927464,470162,31232,901598,970423,856734,695138,1030065,899885,834021,566416,413916,23514,943518,321835,177064,136249,998292,534755,282490,165830,969162,228832,326356,827467,273294,860240,514997,384277,674563,509502,254060,379151,629460,514537,427168,877702,858402,597904,386409,595944,255055,953048,259642,172332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]