SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568373 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568373 [ RunTime:0.002891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963502,306370,626276,544632,119738,511098,322978,217522,834287,489147,418818,291185,185106,720898,317471,676291,988659,558652,524746,128242,43371,441244,398020,205265,924444,754438,974154,923817,649908,818807,761865,4581,346808,558311,592928,1018270,774378,1008292,323439,673264,431741,739740,377710,386664,52558,369894,411699,84160,509673,133325,892926,729756,649816,203059,802408,545675,223065,15275,1047652,863809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]