SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448847 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448847 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806112,325843,337000,1025664,105985,903163,412616,502253,665110,394007,425561,59062,481482,665912,520213,229251,941335,644477,489474,313360,494097,530452,40122,208921,699619,559779,607983,415825,514586,317944,630883,533426,664889,272199,539639,456626,272036,258373,465347,14711,361533,122836,909939,633676,772307,350059,264296,655352,117435,340036,498052,994362,969972,635098,180180,271609,805370,1045958,257603,99116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003919s ]