SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102941 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102941 [ RunTime:0.003183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826792,909873,312756,556853,647244,226517,585766,768162,268341,525789,59250,557154,28259,151358,208388,7943,481890,1026108,82460,918201,714015,592937,964249,405958,280291,37642,162067,587269,507289,875278,701925,421838,1018034,918447,111793,659727,485731,910023,118735,187508,998053,940147,59339,561872,322534,2892,489026,817657,324917,179469,279168,458688,158471,707716,968045,318452,472026,1025628,876465,933738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]