SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002943s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509708 LIMIT 1 [ RunTime:0.002258s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509708 [ RunTime:0.003096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389364,649519,580364,906431,739742,540304,429009,655880,130911,874854,260450,373973,831797,797431,33896,295547,490267,830646,910277,809058,636853,659782,616897,686000,780651,356900,243059,238920,754725,906402,984599,435369,144139,503963,122012,408767,755437,709970,330646,484735,183192,217808,726888,941148,730521,528577,215107,451034,983475,784369,325037,312454,455161,756631,484202,791249,283630,321099,720097,411305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]