SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527096 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527096 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460602,900089,435386,990741,412504,348083,185168,958819,898692,423195,902173,447945,367223,291391,203732,697545,177984,33282,315075,225275,481943,933650,446217,458824,350303,912733,377857,714084,714726,13615,594592,442761,213644,448110,20361,962123,68409,844025,695248,969730,923079,537680,375160,743219,587386,272785,844473,109840,1045302,182321,329473,1006591,920400,444989,898218,775225,943438,178973,513604,59269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]