SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378999 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378999 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466383,663132,878598,465065,148878,159349,756032,434213,146945,794344,278802,1877,704401,112470,42384,308517,237451,16183,226667,1028560,126899,969838,174012,68112,1045722,401188,413993,723089,411063,236742,683047,983181,362511,211549,460577,789504,407080,520698,740484,862859,243215,47280,782226,722251,849307,422616,478191,121251,130872,14031,333615,630780,676723,325911,551801,319082,145662,527448,834460,661872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]