SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521048 LIMIT 1 [ RunTime:0.001328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521048 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965705,478957,557088,605601,456655,859687,856091,628233,443307,519637,455335,467695,274331,663579,169211,180509,788512,882192,806172,210241,197083,1039117,977054,288571,362800,959188,106661,395164,277804,917069,452730,655441,340478,671630,88564,684380,955406,177666,877705,870746,1017221,888428,916584,736919,323359,354161,183762,872175,3536,329267,1007059,775566,607242,393573,100050,851488,798393,723539,710241,132264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]