SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509935 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509935 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626830,250778,573436,649787,759945,321625,91854,942500,281497,704441,941096,991360,994459,615288,637230,978117,160330,415193,551684,177805,463668,116999,816030,31446,215645,913675,609767,838123,615205,233527,967843,636126,428592,632906,241594,209310,518320,633000,1031769,319136,51548,688514,925550,566244,969941,572832,46682,900930,878595,704535,755716,978760,213824,266158,700317,537040,879940,289301,746464,84882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]