SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507769 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507769 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498008,42481,781349,283822,718086,301319,1012949,1011330,668829,234043,394020,109109,1016530,3947,267510,485243,479969,302552,975807,336457,177163,779240,397693,345469,666648,671421,865275,483258,587999,160442,256969,288433,22612,44017,711063,683988,368217,679416,494534,408163,621589,274684,746831,1035916,687477,1007930,123010,345796,968627,67908,912801,56758,51578,218271,64820,587478,365815,30443,852965,306567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507769 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507769 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]