SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981843 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981843 [ RunTime:0.002634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47099,935978,39378,1020891,499510,707016,78527,292903,450890,264763,49548,376847,398760,69518,805135,42483,978872,513868,999453,305147,1007741,104193,163496,946411,290337,814126,839760,851819,199136,757873,364851,476382,854554,800390,946219,1021721,997515,796860,820387,858788,655951,714313,369941,464735,265761,17278,226934,937430,830706,168380,44941,654606,281530,703861,300751,99240,957756,303891,307361,850325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]