SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801112 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801112 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352627,431923,952402,533184,526091,283366,840985,717156,49133,732964,63289,275350,491374,728929,308802,949163,702342,1019322,460009,425633,715513,197837,129632,57928,697953,47831,589243,979209,275132,183146,581359,645094,358269,25425,280728,582260,624406,742655,382341,946422,737935,393828,5552,182261,312153,947809,684632,821451,71569,913377,841953,148053,349033,419117,730203,367196,249412,740075,511911,792613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]