SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040853 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040853 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470478,344651,253586,212190,818135,426402,664702,455299,625829,315352,676548,429416,800235,648326,384498,402790,214654,556288,740140,814904,703710,746218,997475,349808,275375,20675,492889,40697,37484,876360,868459,654348,175654,636614,352403,838104,1048371,13336,594077,598573,358914,262889,1008953,97495,363448,903280,754623,510379,141609,306151,548136,286870,1026555,235134,451963,847168,930195,107079,750735,959936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]