SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984496 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984496 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779486,323898,714273,76145,470707,175660,145784,752491,235777,380956,199063,611337,293214,465026,227344,461124,749384,241023,918267,640592,589391,664648,503940,619681,262527,655944,190253,96571,381386,554371,634955,180041,679687,64104,170464,648490,1040680,774715,298850,841720,391872,109535,536635,150028,651109,684536,296764,29674,175664,666320,275153,928891,1020385,313399,300788,59818,895580,808252,577923,821773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]