SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039070 LIMIT 1 [ RunTime:0.002778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039070 [ RunTime:0.003219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34772,329177,35713,447730,524626,1047989,660880,1038658,775582,1026165,975228,446917,281716,343994,498786,51459,835803,368657,272764,881992,435515,1018632,609355,496648,318426,81206,921895,884998,1011147,144391,630468,778347,937316,535608,95943,751036,428570,295822,223654,341148,170648,431759,1003272,614850,700698,304556,966108,311827,911241,1006066,316130,119578,746982,339788,200337,991840,927776,437795,1005742,862853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002735s ]