SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395209 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395209 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316249,340981,993229,389496,393324,772597,621395,488474,375544,143921,192838,872487,607041,1031268,901063,438238,781450,131570,8768,964758,634001,144791,151455,948031,793355,738676,76880,194652,448720,232119,159214,837382,1035995,169049,640484,369073,420000,557989,840088,7388,768686,485081,924175,851531,1012969,995265,615353,907561,1014882,826158,983809,363247,12690,431289,1016613,813780,813483,137216,194753,58902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]