SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002738s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028111 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028111 [ RunTime:0.004519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487600,173636,1044425,277227,849373,410274,974253,577978,968634,750711,330179,516366,282386,575274,252716,701730,3001,52156,771110,627176,1032575,564067,906042,196955,698352,702471,878042,2403,140455,739339,159931,766554,875542,338837,994300,389236,784738,395866,262148,659186,986792,663428,700229,38959,453185,945171,931941,653044,578277,571649,720547,738171,905505,357355,1010615,823343,697102,717933,779561,105467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]