SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026441 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026441 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304119,185743,470480,78021,682536,481702,937893,535209,209496,141029,330008,738366,427336,783251,2739,783363,640730,106476,465703,238041,581957,545801,940774,210830,36901,159588,58948,264659,492142,199916,289177,684239,815734,790745,804260,1001623,501314,988624,360657,751397,205422,606521,675028,847006,812669,794109,836796,681833,373642,427047,1020822,477340,587508,969078,884478,119500,156209,91480,683379,225844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]