SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369612 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369612 [ RunTime:0.002670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304047,85726,649800,712318,320687,745327,24113,654055,957182,201201,245058,489716,498586,246517,981235,534904,829275,381761,1020376,532188,73785,599075,1002651,1034540,935200,986865,187214,992464,646410,816441,602087,674136,790444,888472,580064,105987,169041,108514,741432,97138,106009,705064,520509,451337,554779,844149,184854,10218,180856,858971,263904,577025,245272,181032,776254,267275,670409,105644,467764,225912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]