SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004907s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445605 LIMIT 1 [ RunTime:0.004287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445605 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343581,406152,771513,468844,663704,714537,118088,757347,813229,692674,355860,975647,764097,136052,115398,60030,1032905,967248,430429,726791,270603,367880,58477,772952,449822,233492,167560,94800,831728,58836,383651,548768,718196,852615,13471,824754,850816,404767,1036674,71825,428994,550635,309826,13713,1043627,320350,241118,110577,454045,677710,718745,490907,346551,905877,166241,149441,185402,183106,256045,639430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]