SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159813 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159813 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748048,919531,83134,547583,588296,598600,478840,543950,235869,1022043,444688,399914,356510,596205,315094,159971,540507,166708,591286,506694,148688,224175,591869,941623,446183,595531,126354,760270,611124,602093,665166,931941,723120,267231,341647,664147,614349,317111,152486,286802,347136,797701,784280,701067,727700,647383,863565,353169,608501,681203,1041400,384503,909514,696827,316557,33878,260217,421434,416871,258825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]