SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574457 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574457 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515081,535810,752332,628693,102357,616441,53173,66046,1048477,597501,846500,100629,617309,567821,652183,786585,227590,711532,842333,1018391,523390,689364,680429,874551,3677,207823,1044623,808732,20782,1033653,847000,853680,1030330,76278,174662,461832,446535,914203,222409,869358,143381,531928,150424,180383,46474,767174,168238,544153,750890,412397,457740,101750,717358,542776,51565,225259,547106,670552,1001435,955830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]