SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488683 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488683 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843805,393699,754178,490323,804452,527855,987573,216957,519204,951863,228963,386383,262346,873900,665574,370488,138455,288864,810527,230053,290650,628249,536351,55960,919133,76217,747244,854048,178522,877852,755315,922079,586367,420055,278561,852445,438530,410826,996694,867961,620755,655628,970183,275004,625664,83786,228680,290493,686037,712955,775062,305136,970152,804786,930107,744892,767962,635074,1026053,333981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]