SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10880 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10880 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886626,220200,888873,541057,40057,818486,916407,13912,482223,763640,507707,655995,946901,366977,969979,444039,386868,900788,626631,431195,272301,301305,65079,262249,691694,438441,883148,296601,775318,277376,1017211,746908,556236,942211,911645,71290,122959,475172,338298,757876,680263,44555,824591,185221,801302,905976,817083,722876,883751,52162,800291,244131,438752,372849,483293,448798,27773,426983,857697,708881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]