SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508307 LIMIT 1 [ RunTime:0.001916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508307 [ RunTime:0.003030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400504,5388,405503,19050,367836,300314,478728,682668,987084,239074,435706,51419,279354,309063,578338,789709,964335,67230,989975,129801,265650,900231,728325,595657,594486,705708,924634,1044754,201751,836730,42801,1024016,963416,560577,74662,736715,148286,126349,998370,186673,689263,365772,839802,328410,958964,941209,609088,423823,466333,810324,133060,666087,167272,301992,500131,254192,369384,496027,695476,857662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]