SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012533 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012533 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855926,755859,683193,886190,25023,377110,1009521,687130,315296,211484,183005,850814,36284,83507,937752,506293,184117,830084,167563,1040897,159258,398249,265100,63290,247300,6759,690077,570548,651686,554575,237989,911626,460004,898974,570300,332140,829841,694808,909473,913151,514289,492510,668690,76056,652435,544784,565937,828720,94934,539706,585618,984721,126582,464493,1044139,239351,984066,906291,434552,239565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]