SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506344 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506344 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303203,804378,221478,208451,236443,904882,859623,531210,643887,69198,389533,292156,54625,195247,615969,388491,402538,222555,408379,46539,789402,820944,246506,1008411,387046,904760,904166,807197,664745,1043005,568272,139770,924447,716103,172173,828460,13714,740825,820633,177620,671851,298514,832875,1047388,620453,93521,521899,452109,28256,517892,579000,377183,741993,444549,841154,164921,722586,256073,305710,750235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]