SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556896 LIMIT 1 [ RunTime:0.001444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556896 [ RunTime:0.004687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426945,1048615,917376,2178,998470,142771,519004,548839,1047130,452814,341893,248634,323136,690054,326690,853989,22458,671545,11369,670936,179801,820263,287460,610827,418815,771889,515986,914790,730084,77587,477001,673799,297600,685402,113255,781103,834801,815517,738267,644654,532083,1020850,58509,808135,63632,883194,1018833,634115,48359,932288,679337,591452,145082,261947,619746,140449,764045,134223,35919,876208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]