SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562804 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562804 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16465,1042447,590325,46268,101188,703511,940334,2017,564480,16067,19105,746083,666549,1037682,1004365,366278,239100,900833,989426,178918,378984,833992,481191,298298,734883,555672,573728,514165,268696,548043,537113,931766,771604,934312,718349,575423,304024,847804,991649,566467,241759,661769,979215,877923,157022,655528,671333,249,237372,208487,379163,112491,890579,363441,1031028,233019,879892,465233,704276,955877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]