SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467517 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467517 [ RunTime:0.004373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471781,138309,787782,655923,405917,1014192,991924,886371,383664,708204,1045859,832718,1036462,587141,662696,960617,269228,814449,983983,41655,85444,942945,695961,266095,503950,668247,790810,79464,375455,723100,960919,456791,658627,1006017,741240,98779,94356,512633,225671,988085,147507,944284,460557,188805,789294,530584,77877,911107,792738,595668,127913,871510,627526,707208,288209,969536,402601,316704,379648,737293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]