SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505594 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505594 [ RunTime:0.003377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300901,234303,36595,168462,303058,886804,646337,834438,844065,222615,373852,915479,883001,371800,261841,72354,661395,507158,637093,656976,992637,567781,574739,465588,820852,688147,638642,282744,679686,420555,255786,406840,199999,258262,682842,654087,114836,95786,300636,847239,609910,101718,906722,524428,557925,432734,733872,555733,663572,89532,802435,140835,555227,896712,562928,655841,857300,179300,661945,2040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]