SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195517 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195517 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654146,113106,188140,1010309,939625,1047254,433483,123283,450583,934598,219715,456002,486624,148944,536257,637368,639601,753650,687281,819583,875264,769363,107214,805018,645713,500567,319400,338124,227851,882703,327946,232266,931363,1030353,261406,102737,527815,586360,23185,935678,1000803,1018266,684206,414027,788330,610823,1022627,972005,936794,68850,293590,924190,244772,1019625,225541,642314,508128,249364,683754,738367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]