SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266124 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266124 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398210,975715,717120,196507,296343,255048,435425,955688,215374,612569,831434,423144,1033864,985958,991678,788130,252518,185196,243727,670340,682886,643856,965588,209185,611928,109845,581672,81776,471547,442466,748261,679666,239558,959102,370861,641080,422434,247901,203650,137476,275403,111724,163948,675201,801960,778000,761983,347016,1002653,988201,284066,808334,83936,996289,1043962,189764,851624,104040,878752,921216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]