SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466506 LIMIT 1 [ RunTime:0.001349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466506 [ RunTime:0.002891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939020,296194,430627,838708,398964,57860,508518,994127,670526,801964,858393,907561,483197,595119,1019502,1030303,149682,484577,522857,830990,893212,638924,52087,629046,755377,20333,21387,230779,382919,152142,978080,723712,88235,497092,910897,715139,392013,412257,83570,537049,265824,377446,560633,526758,868389,708581,343777,514001,402091,113696,13374,556492,88348,972253,40340,407327,986525,720245,791517,700192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]