SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512259 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512259 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493339,289117,87673,552141,547215,613775,65620,927443,339857,640768,228804,556789,479937,185909,897828,919669,814605,246567,45185,262827,910875,921657,836238,489714,1023195,943847,973216,976839,651514,504372,172277,972730,218122,1003696,13537,244012,331362,335937,283263,156440,310975,761891,122183,224246,591153,310536,610160,294058,911194,166460,714271,993468,52333,988341,242946,480951,94922,14060,315119,197457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]