SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522094 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522094 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794819,835801,690669,512555,245403,71061,165258,417117,77983,241615,120897,168107,609354,916153,696953,997921,1043197,678749,337944,95738,490097,957416,836384,996215,296648,540640,645710,906444,631711,112710,305880,520974,770954,333902,34978,661512,644625,199384,712045,835485,6958,148263,10076,496507,433215,425589,52163,257332,198716,746675,268104,364772,301734,291325,468227,101957,367363,334615,1042805,749682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]