SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551995 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551995 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490616,189913,237935,10047,117274,671691,960244,787278,868156,395750,880521,835943,74603,489168,973533,175922,870010,542799,340962,790196,650888,195304,78187,1032908,24378,503062,149017,663545,244251,1002089,166651,375619,255384,134164,482723,254181,861384,721575,742578,431375,162875,196335,517336,458419,788472,752215,809528,511705,17202,801282,976433,287570,204861,430556,473841,645782,522599,172156,52485,334405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]