SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101817 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101817 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877404,387584,181231,221773,244030,779371,574753,374545,740143,692793,802589,627165,788055,529830,24595,666544,402144,716406,770451,888629,717045,175058,585269,306876,773334,730467,33628,334468,780126,695764,354444,878116,832876,342101,701645,694854,319313,665020,365347,49396,568783,775872,70153,793233,278786,1006717,106444,531459,674867,774470,753128,39751,94165,353371,230000,1043987,41899,718955,375489,869374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]