SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104611 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104611 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914801,50812,646644,319932,874068,638721,207238,390557,164420,618212,17031,702009,583566,688081,627526,1005222,185858,1011931,925750,40801,393650,101653,182491,848768,754978,748167,134636,70181,45802,541456,647721,180275,1048603,189531,901697,271716,79884,204153,107056,515925,751561,249834,558771,990239,357191,702306,721456,123420,392182,136446,148366,525761,521331,444853,719901,235249,633446,739512,967287,155474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]