SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340816 LIMIT 1 [ RunTime:0.001879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340816 [ RunTime:0.009384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943457,889490,535400,940097,253342,348999,382217,294171,911412,493238,285228,1046068,1033164,262666,778466,167440,78393,416313,259881,146840,408058,27818,713879,68499,760917,619402,461332,430377,103776,466173,128709,1002975,697278,851517,47521,304446,957977,889443,754659,925780,745780,190313,437282,366076,269910,382315,176767,191246,981731,367214,113095,586162,706363,548090,409263,461775,830272,240196,438037,1039233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001032s ]