SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305203 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305203 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793889,1015457,404575,126167,325029,21120,187462,472410,664150,344354,593429,930177,35970,685557,345740,39466,703027,219529,572002,207542,564962,1027168,311047,447356,993545,686371,140476,916920,74664,350262,213011,491575,712633,763294,935633,322283,32008,290250,423045,715336,262170,60571,613717,1014828,514716,906425,699624,335697,424897,671691,40098,820867,274374,891641,350310,478407,214574,264334,425206,15155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]