SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711793 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711793 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221395,723139,429031,648411,169331,1021887,117413,110930,635244,527542,157281,557059,122071,149744,485684,762682,196692,1030911,765090,1035069,159031,543275,366036,569663,597704,446656,28888,896892,1014851,317593,26667,150171,423782,269209,792653,221858,990677,191653,610949,33005,638352,764851,44147,453747,643722,252816,305084,346968,360757,971420,926866,849596,726936,730265,2934,187255,482100,711780,47180,203085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]